SELECT name, plsql_code_type, plsql_optimize_level
FROM   user_plsql_object_settings;
